/**   
* @Title: FormSQLUtil.java 
* @Package com.kerrykidz.workflow.util 
* @Description: 
* Copyright: Copyright (c) 2014 
* Company:wuwh team by iss
* @author: zhuss   
* @date: 2014年11月4日 下午1:16:28 
* @version: V1.0
*
*/
package com.kerrykidz.workflow.util;

public class FormSQLUtil {

	//请假
	public static String leaveSQL = "select hl.PK_LEAVE_ID ID_,hl.STATUS from HRM_LEAVE hl where status > '2'";
	
	//库存调整
	public static String stockSQL = "select ssa.PK_STGADJ_ID ID_,ssa.STATUS from scm_stg_adj ssa where status > '2'";
	
	//付款
	public static String paySQL = "select sp.PK_PAYFORM_ID ID_,sp.STATUS from scm_payform sp where status > '2'";
	
	//采购订单
	public static String orderSQL = "select spo.PK_PURORD_ID ID_,spo.STATUS from scm_pur_order spo where status > '2'";
	
	//促销
	public static String discountSQL = "select pc.PK_CAMP_ID ID_,pc.STATUS from pro_campaign pc where status > '2'";
	
	//定价
	public static String priceSQL = "select spp.PK_PRICE_ID ID_,spp.STATUS from scm_prd_price spp where status > '2'";
	
	//客户服务
	public static String serverSQL = "select ccf.PK_CAREFORM_ID ID_,ccf.STATUS from CAR_CARE_FORM ccf where status > '2'";
}
